Hệ thống quản lý phương tiện trực tuyến bằng PHP

7.317 lượt xem;

vehiclestorebookpaid.php
project /

1 <?php
2 include("header.php");
3 include("sidebar.php");
4 include("dbconnection.php");
5 $sql = mysql_query("select * from vehiclestore where vehicleid=$_POST[vahicleid]");
6 $row = mysql_fetch_array($sql);
7 ?>
8 <?
9 if(isset($_POST['submit']))
10 {
11 //echo $_POST['comments'];
12
13 $sql = false;
14 $date = date("Y-m-d");
15
16 $sql ="insert into booking(vehicleid,custid,purchasedate,comments,paid,paymenttype) values('$_POST[vahicleid]','$_SESSION[custid]','$date','$_POST[comments]','$_POST[vehprice]','Pending')";
17 if (!mysql_query($sql,$con))
18   {
19   die('Error: ' . mysql_error());
20   }
21 $sql = mysql_query("update vehiclestore set status='Sold' where vehicleid='$_POST[vahicleid]'");
22
23     //if (!mysql_query($sql,$con))
24       if($sql !== true)
25       {
26       die('Error: ' . mysql_error());
27       echo "not working";
28       }
29 }
30
31 $sql = mysql_query("select * from vehiclestore where vehicleid='$_POST[vahicleid]'");
32 $row = mysql_fetch_array($sql);
33 ?>
34
35         <div id="main">
36         <h3>Vehicle store</h3>
37
38
39         <table width="538" border="1">
40           <tr>
41             <td height="45" colspan="2"><h2>Vehicle booked successfully...</h2></td>
42           </tr>
43           <tr>
44             <td width="268">
45             <p><img src="upload/<?= $row['images']; ?>" width="208" height="130" align="left" /><br />
46               <br />
47             </p></td>
48             <td width="246"><p><strong>Vehicle Name:</strong><?= $row['vehname']; ?><br />
49               <strong>Model:</strong> <?= $row['model']; ?> <br />
50               <strong> Brand:</strong> <?= $row['brand']; ?><br />
51               <br />
52               <br />
53             </p></td>
54           </tr>
55           <tr>
56             <td>Other Information</td>
57             <td><p><?= $row['description']; ?></p><br />
58               </td>
59           </tr>
60           <tr>
61             <td colspan="2"><strong>Estimated price: Rs.<?= $row['estprice']; ?></strong></td>
62           </tr>
63           <tr>
64             <td> </td>
65             <td> </td>
66           </tr>
67           </table>
68         </div>
69
70 
71 </div>
72
73 <?php
74 include("footer.php");
75 ?>